<?php

namespace app\common\model;

use think\Db;
use think\Model;

/**
 * 市场推广申请
 * @author lcx
 * @date 2019-03-18
 */
class OaDealerApplyModel extends Model
{

    // 表名
    protected $name = 'oa_dealer_apply';

    // 列表查询
    public function getAll($where, $join, $page, $pageSize, $field, $order = 'create_time desc')
    {
        if ($pageSize > 0) {
            $result = $this->alias('a')
                ->where($where)
                ->join($join)
                ->field($field)
                ->page($page, $pageSize)
                ->order($order)
                ->select();
        } else {
            $result = $this->alias('a')
                ->where($where)
                ->join($join)
                ->field($field)
                ->order($order)
                ->select();
        }

        return $result;
    }

    // 数量查询
    public function getCount($where, $join = [])
    {
        $result = $this->alias('a')->where($where)
            ->join($join)
            ->count();
        return $result;
    }

    // 单个查询
    public function getOne($where, $join=[], $field='*')
    {
        $result = $this->alias('a')->where($where)
            ->join($join)
            ->field($field)
            ->find();
        return $result;
    }

    // 添加操作
    public function add($data)
    {
        $result = $this->insertGetId($data);
        return $result;
    }

    // 编辑操作
    public function edit($where, $data)
    {
        $result = $this->where($where)->update($data);
        return $result;
    }

}
